﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MissingPartsReport.aspx.cs" Inherits="MLY.Reports.DataReports.MissingPartsReport" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<%@ Register Assembly="DevExpress.Web.v11.1.Linq, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Data.Linq" TagPrefix="dx" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web.ASPxPanel"
  TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web.ASPxRoundPanel"
  TagPrefix="dx" %>
<%@ Register assembly="DevExpress.Web.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxLoadingPanel" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v11.1, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v11.1.Export, Version=11.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>


<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title><asp:Literal ID="TitleLiteral" Text="<%$ Dict:Reports.MissingPartsReport %>" runat="server"></asp:Literal></title>
    <link href="/Style/General_Style_v9.css" rel="stylesheet" type="text/css" />
    <link href="../../Style/ReportsStylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div  class="InerTextStyle">
        חוסרים:
        <dx:ASPxGridView ID="MissingPartsGrid" runat="server"  DataSourceID="MissingItemsDataSource"
        AutoGenerateColumns="true"  EnableCallBacks="False" SettingsPager-RenderMode="Lightweight"
        EnableTheming="False" KeyFieldName="Catalogue code" Settings-ShowFilterRow="true" Settings-ShowGroupButtons="true"
        Settings-ShowFilterBar="Hidden" Settings-ShowFilterRowMenu="True" Settings-ShowGroupedColumns="True" Settings-ShowGroupPanel="True" Settings-UseFixedTableLayout="True">
        <SettingsBehavior AllowFocusedRow="True" ColumnResizeMode="NextColumn" AutoFilterRowInputDelay="2500"  />
        <SettingsPager RenderMode="Lightweight"></SettingsPager>
        <Styles Header-Wrap="True"></Styles>
        </dx:ASPxGridView>
        <dx:ASPxGridViewExporter ID="gridExport" runat="server" GridViewID="MissingPartsGrid" ></dx:ASPxGridViewExporter>
        <table cellpadding="5" cellspacing="0">
            <tr>
            <td>
                <%--<div onclick="javascript:moveDemoToStep4();">--%>
                <dx:ASPxButton Id="ExportToXLS" runat="server" Text="Export to XLS" UseSubmitBehavior="False"
                    OnClick="btnXlsExport_Click"   ></dx:ASPxButton>
                <%--</div> --%>                   
            </td>
            <td>
                <dx:ASPxButton Id="ExportToXLSx" runat="server" Text="Export to XLSx" UseSubmitBehavior="False"
                    OnClick="btnXlsxExport_Click"></dx:ASPxButton>
            </td>
            <td>
                <dx:ASPxButton Id="ExportToPDF" runat="server" Text="Export to PDF" UseSubmitBehavior="False"
                    OnClick="btnPdfExport_Click"></dx:ASPxButton>
            </td>
            </tr>
            </table>
        
        <%--<asp:GridView ID="MissiongPartsGrid" runat="server" AutoGenerateColumns="true" DataSourceID="MissingItemsDataSource"
         HeaderStyle-BackColor="#86C2FF">
        </asp:GridView>--%>
            
        <br /><br />
        הזמנות רכש:
        <dx:ASPxGridView ID="ClientOrdersDxGridview" runat="server" AutoGenerateColumns="false" DataSourceID="ClientsOrdersDataSource"  
        EnableCallBacks="False" SettingsPager-RenderMode="Lightweight"
        EnableTheming="False" KeyFieldName="WorkOrderId" Settings-ShowFilterRow="true" Settings-ShowGroupButtons="true"
        Settings-ShowFilterBar="Hidden" Settings-ShowFilterRowMenu="True" Settings-ShowGroupedColumns="True" Settings-ShowGroupPanel="True" Settings-UseFixedTableLayout="True">
        <Columns>
            <dx:GridViewDataTextColumn FieldName="ContractorOrganizationName" Caption="שם הספק"></dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="WorkOrderId" Caption="מספר הזמנה">
            <CellStyle HorizontalAlign="Left"></CellStyle>
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="ContractorCatalogueCode" Caption="מק&quot;ט"></dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Quantity" Caption="כמות"><CellStyle HorizontalAlign="Left"></CellStyle></dx:GridViewDataTextColumn>
        </Columns>
        
        </dx:ASPxGridView>
        <%--<asp:GridView ID="ClientOrdersGridview" runat="server" AutoGenerateColumns="false" DataSourceID="ClientsOrdersDataSource"  HeaderStyle-BackColor="#86C2FF">
        <Columns>
            <asp:BoundField DataField="ContractorOrganizationName" HeaderText="שם הספק" />
            <asp:BoundField DataField="WorkOrderId" HeaderText="מספר הזמנה" />
            <asp:BoundField DataField="ContractorCatalogueCode" HeaderText="מק&quot;ט" />
        </Columns>
        <EmptyDataTemplate>
            אין הזמנות רכש
        </EmptyDataTemplate>
        </asp:GridView>--%>
        <br /><br />
        ביקושים:
        <dx:ASPxGridView ID="ContractorOrdersDXGridview" runat="server" AutoGenerateColumns="false" DataSourceID="ContractorOrdersDataSource"
         EnableCallBacks="False" SettingsPager-RenderMode="Lightweight"
         EnableTheming="False" KeyFieldName="WorkOrderId" Settings-ShowFilterRow="true" Settings-ShowGroupButtons="true"
         Settings-ShowFilterBar="Hidden" Settings-ShowFilterRowMenu="True" Settings-ShowGroupedColumns="True"
         Settings-ShowGroupPanel="True" Settings-UseFixedTableLayout="True" Styles-Row-HorizontalAlign="Left">
        <Columns>
            <dx:GridViewDataTextColumn FieldName="CustomerOrganizationName" Caption="שם הלקוח"></dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="WorkOrderId" Caption="מספר הזמנה" ><CellStyle HorizontalAlign="Left"></CellStyle></dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="ContractorCatalogueCode" Caption="מק&quot;ט"></dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="Quantity" Caption="כמות"><CellStyle HorizontalAlign="Left"></CellStyle></dx:GridViewDataTextColumn>
        </Columns>        
        </dx:ASPxGridView>
        <%--<asp:GridView ID="ContractorOrdersGridview" runat="server" AutoGenerateColumns="false" DataSourceID="ContractorOrdersDataSource"  HeaderStyle-BackColor="#86C2FF">
        <Columns>
            <asp:BoundField DataField="CustomerOrganizationName" HeaderText="שם הלקוח"  />
            <asp:BoundField DataField="WorkOrderId" HeaderText="מספר הזמנה" />
            <asp:BoundField DataField="ContractorCatalogueCode" HeaderText="מק&quot;ט" />
        </Columns>
        <EmptyDataTemplate>
            אין הזמנות לקוח
        </EmptyDataTemplate>
        </asp:GridView>--%>
        <asp:SqlDataSource ID="MissingItemsDataSource" runat="server" SelectCommandType="StoredProcedure"
        ConnectionString="<%$ ConnectionStrings:MLYConnectionString %>" SelectCommand="SCCover_MissingPartsReport"></asp:SqlDataSource>         
        <asp:SqlDataSource ID="ClientsOrdersDataSource" runat="server" SelectCommandType="StoredProcedure" 
        ConnectionString="<%$ ConnectionStrings:MLYConnectionString %>" SelectCommand="SCC_GetClientOrders"></asp:SqlDataSource> 
        <asp:SqlDataSource ID="ContractorOrdersDataSource" runat="server" SelectCommandType="StoredProcedure"
        ConnectionString="<%$ ConnectionStrings:MLYConnectionString %>" SelectCommand="SCC_GetSupplierOrders"></asp:SqlDataSource> 
    </div>
    </form>
</body>
</html>
